1
00:00:00,210 --> 00:00:08,040
‫So it is quite easy and I think natural if you want to use another DBMS, such as my school or another

2
00:00:08,040 --> 00:00:15,230
‫database in PostgreSQL, so I'm going to change the current database to another one in PostgreSQL.

3
00:00:15,230 --> 00:00:15,450
‫Well.

4
00:00:16,310 --> 00:00:20,120
‫But before I do that, I need to create a database.

5
00:00:21,730 --> 00:00:26,740
‫So these are my workspaces, but I'm not going to need them now.

6
00:00:28,190 --> 00:00:31,220
‫So I'm going to disconnect from the MSF three database.

7
00:00:32,480 --> 00:00:42,080
‫Then exit from Métis Point now, I think it's good practice to stop PostgreSQL for a while, then started

8
00:00:42,080 --> 00:00:45,350
‫again, but this is just one of my old habits.

9
00:00:46,490 --> 00:00:48,110
‫That I pass on to you.

10
00:00:49,540 --> 00:00:54,940
‫OK, so now I'm going to get the full name of the PostgreSQL user by these commands.

11
00:00:55,910 --> 00:01:06,200
‫Name is most grass type as you post grass to get into PostgreSQL, you well use Herschelle.

12
00:01:07,490 --> 00:01:13,040
‫Now, here, you're not going to need a password because the default installation, there is no password.

13
00:01:14,090 --> 00:01:17,720
‫Now, the logic is the same if there is a password, you will need to type it.

14
00:01:18,560 --> 00:01:24,800
‫All right, then list databases with PSU, you will know.

15
00:01:25,710 --> 00:01:27,510
‫And here are the database's.

16
00:01:28,860 --> 00:01:40,980
‫So now I'm going to create a user first by using the Create User Command great user user for MSF P and

17
00:01:40,980 --> 00:01:44,430
‫we're going to enter my very strong password two times.

18
00:01:45,120 --> 00:01:48,810
‫And now let's create a database by create DB.

19
00:01:49,260 --> 00:01:54,250
‫That's the command that is owned by the user for MSF that we just created.

20
00:01:54,780 --> 00:02:02,650
‫So create DB DB for MSF owner equals user for MSF.

21
00:02:03,450 --> 00:02:03,960
‫All right.

22
00:02:03,960 --> 00:02:06,060
‫So let's list the databases.

23
00:02:07,520 --> 00:02:15,290
‫And sure enough, here I have the database, so I am now finished with PostgreSQL and I'm going to exit.

24
00:02:16,330 --> 00:02:19,760
‫And I'll open MSF console in quiet mode again.

25
00:02:20,360 --> 00:02:25,060
‫Hey, it's finally open and let's just quickly check the TV status.

26
00:02:25,480 --> 00:02:30,060
‫So as you can see here, it connects to the default database.

27
00:02:30,580 --> 00:02:34,760
‫So now I'm going to disconnect from that database and that's successful.

28
00:02:35,320 --> 00:02:44,980
‫Now I'm going to connect to my new database, DB for MSF, DV Connect user for MSF, one, two, three,

29
00:02:44,980 --> 00:02:49,300
‫four, and localhost colon five, four, three, two.

30
00:02:49,360 --> 00:02:57,250
‫Slashed before as best one, two, three, four is my strong password, as you can see.

31
00:02:58,230 --> 00:03:01,980
‫All right, so now let's check the status of the database.

32
00:03:02,340 --> 00:03:02,860
‫OK, good.

33
00:03:03,150 --> 00:03:05,730
‫So here you see that I have connected the new one.

34
00:03:06,640 --> 00:03:11,020
‫And you can now work with in the workspaces add delete.

35
00:03:12,310 --> 00:03:14,410
‫It's all on you now.